﻿
using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace Oliving.Edge.Model.Models
{
    ///<summary>
    ///
    ///</summary> 

    [SugarTable("DTSN_Canning")]
    [Serializable]
    public class DTSN_Canning
    {
        public DTSN_Canning()
        {
        }


        /// <summary> 
        /// Desc: 
        /// Default: 
        /// Nullable:False 
        /// </summary> 

        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnName = "Canning_ID")]
        public int Canning_ID { get; set; }



        [SugarColumn(ColumnDescription = "装载类型", ColumnName = "Canning_Type")]
        public int Canning_Type { get; set; }


        /// <summary> 
        /// Desc:车牌号 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Car", ColumnDescription = "车牌号", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Car { get; set; }



        /// <summary> 
        /// Desc:车辆卡号 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_CarCode", ColumnDescription = "车辆卡号", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_CarCode { get; set; }



        /// <summary> 
        /// Desc:客户名称 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Customer", ColumnDescription = "客户名称", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Customer { get; set; }



        /// <summary> 
        /// Desc:通道编号 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_TongDaoID", ColumnDescription = "通道编号", IsNullable = true)]
        public int? Canning_TongDaoID { get; set; }



        /// <summary> 
        /// Desc:皮重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Tare", ColumnDescription = "皮重", IsNullable = true)]
        public decimal? Canning_Tare { get; set; }



        /// <summary> 
        /// Desc:毛重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_GrossWeight", ColumnDescription = "毛重", IsNullable = true)]
        public decimal? Canning_GrossWeight { get; set; }



        /// <summary> 
        /// Desc:净重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_NetWeight", ColumnDescription = "净重", IsNullable = true)]
        public decimal? Canning_NetWeight { get; set; }



        /// <summary> 
        /// Desc:品种 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Varieties", ColumnDescription = "品种", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Varieties { get; set; }





        [SugarColumn(ColumnName = "Canning_Date", ColumnDescription = "装载日期", IsNullable = true)]
        public DateTime? Canning_Date { get; set; }

        /// <summary> 
        /// Desc:开始时间 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_BeginTime", ColumnDescription = "开始时间", IsNullable = true)]
        public DateTime? Canning_BeginTime { get; set; }



        /// <summary> 
        /// Desc:结束时间 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_EndTime", ColumnDescription = "结束时间", IsNullable = true)]
        public DateTime? Canning_EndTime { get; set; }



        /// <summary> 
        /// Desc:装载次数 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Count", ColumnDescription = "装载次数", IsNullable = true)]
        public int? Canning_Count { get; set; }



        /// <summary> 
        /// Desc:状态 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_State", ColumnDescription = "状态", IsNullable = true)]
        public int? Canning_State { get; set; }



        /// <summary> 
        /// Desc:创建时间 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_CreateTime", ColumnDescription = "创建时间", IsNullable = true)]
        public DateTime? Canning_CreateTime { get; set; }



        /// <summary> 
        /// Desc:插入时间 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_InsertTime", ColumnDescription = "插入时间", IsNullable = true)]
        public DateTime? Canning_InsertTime { get; set; }



        /// <summary> 
        /// Desc:备注 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Remark", ColumnDescription = "备注", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Remark { get; set; }



        /// <summary> 
        /// Desc:订单 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Order", ColumnDescription = "订单", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Order { get; set; }



        /// <summary> 
        /// Desc:重量序列号 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_weightserialcode", ColumnDescription = "重量序列号", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_weightserialcode { get; set; }



        /// <summary> 
        /// Desc:客户编码 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_accountcode", ColumnDescription = "客户编码", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_accountcode { get; set; }



        /// <summary> 
        /// Desc:客户名称 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_accountname", ColumnDescription = "客户名称", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_accountname { get; set; }



        /// <summary> 
        /// Desc:运输商编码 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_carrycode", ColumnDescription = "运输商编码", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_carrycode { get; set; }



        /// <summary> 
        /// Desc:运输商名称 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_carryname", ColumnDescription = "运输商名称", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_carryname { get; set; }



        /// <summary> 
        /// Desc:品种编码 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_procode", ColumnDescription = "品种编码", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_procode { get; set; }



        /// <summary> 
        /// Desc:品种名称 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_proname", ColumnDescription = "品种名称", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_proname { get; set; }



        /// <summary> 
        /// Desc:车型 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_trucktype", ColumnDescription = "车型", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_trucktype { get; set; }



        /// <summary> 
        /// Desc:车辆标载 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_truckweight", ColumnDescription = "车辆标载", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_truckweight { get; set; }



        /// <summary> 
        /// Desc:仓库 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_storage", ColumnDescription = "仓库", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_storage { get; set; }



        /// <summary> 
        /// Desc:登记时间 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_OrderCreatetime", ColumnDescription = "登记时间", IsNullable = true)]
        public DateTime? Canning_OrderCreatetime { get; set; }



        /// <summary> 
        /// Desc:业务类型 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Orderbstype", ColumnDescription = "业务类型", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Orderbstype { get; set; }



        /// <summary> 
        /// Desc:请发量 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Orderpreweight", ColumnDescription = "请发量", IsNullable = true)]
        public decimal? Canning_Orderpreweight { get; set; }



        /// <summary> 
        /// Desc:皮重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Ordertareweight", ColumnDescription = "皮重", IsNullable = true)]
        public decimal? Canning_Ordertareweight { get; set; }



        /// <summary> 
        /// Desc:毛重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Ordergrossweight", ColumnDescription = "毛重", IsNullable = true)]
        public decimal? Canning_Ordergrossweight { get; set; }



        /// <summary> 
        /// Desc:净重 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Ordernetweight", ColumnDescription = "净重", IsNullable = true)]
        public decimal? Canning_Ordernetweight { get; set; }



        /// <summary> 
        /// Desc:车辆状态 Y 已装车 N 未装车 
        /// Default: 
        /// Nullable:True 
        /// </summary> 

        [SugarColumn(ColumnName = "Canning_Orderstatus", ColumnDescription = "车辆状态 Y 已装车 N 未装车", IsNullable = true, Length = 100, ColumnDataType = "nvarchar")]
        public string Canning_Orderstatus { get; set; }


    }

}
